home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
Cream of the Crop 1
/
Cream of the Crop 1.iso
/
BUSINESS
/
SAS50.ARJ
/
FILES.CLA
< prev
next >
Wrap
Text File
|
1991-06-06
|
5KB
|
171 lines
CLIENTS FILE,PRE(CLI),CREATE,RECLAIM
CLIENT_KEY KEY(CLI:CLIENT),DUP,NOCASE,OPT
ZIP_KEY KEY(CLI:ZIP),DUP,NOCASE,OPT
COMMENTS MEMO(490) !Comments
RECORD RECORD
CLIENT STRING(32) !Client Name
ORDEREDBY STRING(32) !Ordered By
ADD1 STRING(32) !Address #1
ADD2 STRING(32) !Address #2
CITY STRING(17) !City
STATE STRING(3) !State
ZIP STRING(10) !Zip Code
DAYPHONE DECIMAL(10,0) !Day Phone
EXTENSION STRING(10) !Extension
EVEPHONE DECIMAL(10,0) !Eve Phone
FAXPHONE DECIMAL(10,0) !Fax Phone
PRICECLASS BYTE !Price Class
. .
GROUP,OVER(CLI:COMMENTS)
CLI_MEMO_ROW STRING(70),DIM(7)
.
INVNTORY FILE,PRE(INV),CREATE,RECLAIM
BY_GROUP KEY(INV:GROUPNAME,INV:PARTNUM),NOCASE,OPT
BY_PARTNUM KEY(INV:PARTNUM),NOCASE,OPT
BY_VENDOR KEY(INV:VENDOR,INV:GROUPNAME,INV:PARTNUM),DUP,NOCASE,OPT
COMMENTS MEMO(108) !Printable Comments
RECORD RECORD
PARTNUM STRING(16) !Part Number
GROUPNAME STRING(10) !Group Name
PRODDESC STRING(27) !Product Description
COST REAL !Item Cost
MFGRETAIL REAL !MFG Retail Price
CLASS1 REAL !Price Class 1
CLASS2 REAL !Price Class 2
CLASS3 REAL !Price Class 3
STOCK_ADJUST STRING(3) !Adjust Stock on Sold Items?
TAXABLE STRING(3) !Taxable Flag
VENDOR STRING(32) !Vendor Name
NOTES1 STRING(27) !Non-Print #1
NOTES2 STRING(27)
NOTES3 STRING(27)
NOTES4 STRING(27)
ON_HAND REAL !Qty On Hand
ON_ORDER REAL !Qty On Order
MIN_QTY REAL !Minimum Quantity
. .
GROUP,OVER(INV:COMMENTS)
INV_MEMO_ROW STRING(27),DIM(4)
.
ORDERS FILE,PRE(ORD),CREATE,RECLAIM
ORDER_KEY KEY(ORD:ORDER_NUM),NOCASE,OPT
TYPE_KEY KEY(ORD:TYPE,ORD:CLIENT,ORD:DATE),DUP,NOCASE,OPT
TYPE_DATE KEY(ORD:TYPE,ORD:DATE),DUP,NOCASE,OPT
NOTES MEMO(87) !Order Notes
RECORD RECORD
ORDER_NUM LONG !Order Number
INVOICE_NUM LONG !Invoice #
INV_ADJUSTED STRING(1) !Inventory Adjusted?
CLIENT STRING(32) !Client Name
TYPE STRING(9) !Order Type
DATE LONG !Order Date
SALESPERSON STRING(32) !Salesperson
ORDERREF STRING(28) !Order Reference
PRICECLASS BYTE !Price Class
TAXPCT REAL !Tax Percentage
TAX REAL !Tax on Order
PAYMETHOD STRING(20) !Method of Payment
TERMS STRING(13) !Payment Terms
PO STRING(25) !Purchase Order Number
CCNUM STRING(25) !Credit Card Number
EXPDATE STRING(10) !Credit Card Expiration Date
AUTHORIZE STRING(12) !CC Authorization
SURCHARGE REAL !Credit Card Surcharge
SHIPTO STRING(32) !Ship To - Name
SHIPADD1 STRING(32) !Ship To - Address #1
SHIPADD2 STRING(32) !Ship To - Address #2
SHIPCITY STRING(17) !Ship To - City
SHIPSTATE STRING(3) !Ship To - State
SHIPZIP STRING(10) !Ship To - Zip Code
SHIPATTN STRING(26) !Ship To - Attention
COST REAL !Order Cost
SUBTOTAL REAL !Order Subtotal
TAXABLE REAL
. .
GROUP,OVER(ORD:NOTES)
ORD_MEMO_ROW STRING(29),DIM(3)
.
ITEM_ORD FILE,PRE(ITE),CREATE
ORD_KEY KEY(ITE:ORDER_NUM),DUP,NOCASE,OPT
RECORD RECORD
ORDER_NUM LONG !Order Number
PART_NUM STRING(16) !Part Number
QTY LONG !Quantity
UNITCOST REAL !Unit Cost
PRODDESC STRING(27) !Product Description
ORDERPRICE REAL !Order Price
. .
PAYMETHD FILE,PRE(PAY),CREATE,RECLAIM
METHOD_KEY KEY(PAY:METHOD_PAY),NOCASE,OPT
RECORD RECORD
METHOD_PAY STRING(20) !Method Of Payment
. .
TERMS FILE,PRE(TER),CREATE,RECLAIM
TERM_KEY KEY(TER:TERMS),NOCASE,OPT
RECORD RECORD
TERMS STRING(13) !Terms of Order
. .
VENDORS FILE,PRE(VEN),CREATE,RECLAIM
VEN_KEY KEY(VEN:VENDOR),DUP,NOCASE,OPT
VEN_NUM_KEY KEY(VEN:VENDOR_NUM),NOCASE,OPT
ZIP_KEY KEY(VEN:ZIP),DUP,NOCASE,OPT
COMMENTS MEMO(350) !Comments
RECORD RECORD
VENDOR_NUM LONG
VENDOR STRING(32) !Vendor Name
ADD1 STRING(32) !Address #1
ADD2 STRING(32) !Address #2
CITY STRING(17) !City
STATE STRING(3) !State
ZIP STRING(10) !Zip Code
CONTACT STRING(32) !Contact Person
DAYPHONE DECIMAL(10,0) !Phone Number
EXTENSION STRING(10) !Extension
EVEPHONE DECIMAL(10,0) !Phone Number #2
FAXPHONE DECIMAL(10,0) !Fax Phone Number
ACCTNUM STRING(20) !Account Number
TERMS STRING(32) !Terms
. .
GROUP,OVER(VEN:COMMENTS)
VEN_MEMO_ROW STRING(70),DIM(5)
.
COMPANY FILE,PRE(COM),CREATE,RECLAIM
RECORD RECORD
COMPANY STRING(32)
ADD1 STRING(32)
ADD2 STRING(32)
CITY STRING(17)
STATE STRING(3)
ZIP STRING(10)
PHONE STRING(14)
TAXPCT REAL
INVOICE_NUM LONG
COM1 STRING(60)
COM2 STRING(60)
COM3 STRING(60)
FIN3 DECIMAL(10,10)
TIMEFIN3 STRING(5)
FIN4 DECIMAL(10,10)
TIMEFIN4 STRING(5)
FIN5 DECIMAL(10,10)
TIMEFIN5 STRING(5)
C1MARGIN REAL !Class 1 Default Margin
C2MARGIN REAL !Class 2 Default Margin
C3MARGIN REAL !Class 3 Default MArgin
PRINTER STRING(5)
. .
SALESPER FILE,PRE(SAL),CREATE,RECLAIM
SALES_KEY KEY(SAL:SALESPERSON),NOCASE,OPT
RECORD RECORD
SALESPERSON STRING(32) !Salesperson Name
. .